#ifndef PANELASDAO_H
#define PANELASDAO_H

#include "dao.h"

#include "../entity/panela.h"

CUSTOM_DAO(Panela, "", DEFAULT_PAGE_SIZE, "id_deppanela",
           Query("select dep_p.id_deppanela, p.descricao, p.tara, p.codpanela" \
                 " from prdeppanela dep_p" \
                 " join prpanela p on p.id_panela = dep_p.id_panela")
           .where("(dep_p.excluido = 0)")
           .orderBy("dep_p.postela, p.descricao"),
           DEFAULT_COUNT_QUERY)

#endif // PANELASDAO_H
